package com.linked.basemanage.dictionary.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.linked.basemanage.dictionary.bean.po.DictoryInfoPO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author :dbq
 * @date : 2023/1/13 12:48
 * @description : desc
 */
@Mapper
public interface IDictionaryInfoMapper extends BaseMapper<DictoryInfoPO> {
    @Select("SELECT di.`value` FROM basemanage_dictionary_info di " +
            "WHERE di.data_status = 1 AND di.dictionary_code = #{dictionaryCode} AND di.use_location = #{useLocation}")
    List<DictoryInfoPO> queryDictoryList(@Param("useLocation") String useLocation,@Param("dictionaryCode") String dictionaryCode);
}
